﻿CREATE TABLE [dbo].[TipoConstrucao] (
    [TipoConstrucaoId] INT           IDENTITY (1, 1) NOT NULL,
    [Nome]             NVARCHAR (80) NOT NULL,
    PRIMARY KEY CLUSTERED ([TipoConstrucaoId] ASC)
);

SET IDENTITY_INSERT [dbo].[TipoConstrucao] ON
INSERT INTO [dbo].[TipoConstrucao] ([TipoConstrucaoId], [Nome]) VALUES (1, N'Casa Madeira')
INSERT INTO [dbo].[TipoConstrucao] ([TipoConstrucaoId], [Nome]) VALUES (2, N'Casa Alvenaria')
INSERT INTO [dbo].[TipoConstrucao] ([TipoConstrucaoId], [Nome]) VALUES (3, N'Edificio Simples')
INSERT INTO [dbo].[TipoConstrucao] ([TipoConstrucaoId], [Nome]) VALUES (4, N'Edificio Medio')
INSERT INTO [dbo].[TipoConstrucao] ([TipoConstrucaoId], [Nome]) VALUES (5, N'Edificio Grande')
SET IDENTITY_INSERT [dbo].[TipoConstrucao] OFF
